![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Oracle Office SystemsThe Oracle Office system is designed to provide office services such as messaging and scheduling. Oracle Office is a client/server application that uses the Oracle RDBMS system on the servers. The Oracle Office system also uses a replication method to duplicate data throughout the system. The Oracle Office system consists of the following components:
Oracle Office is a complex suite of components that can assist you in your day-to-day operations by providing general office services. In the scope of this book, I address only the Oracle Office server components and RDBMS. System CharacteristicsThe Oracle Office system is designed to service many individual users simultaneously. Your office environment may consist of just a few or hundreds of clients accessing the same server. Because of this variety, the system appears very similar to the OLTP system in both characteristics and function. Some of these characteristics are listed here:
These characteristics may vary slightly based on your particular configuration and the number of users you service. Some components (such as the uptime requirement) can require additional hardware resources to provide additional fault tolerance. Design and Tuning HintsBecause the system operates in a manner similar to that of a traditional OLTP system, many of the design and tuning parameters are similar to those of the OLTP system. The goals are to achieve good response times and a high level of fault tolerance. Design The layout for the office system is almost identical to that of the OLTP system except that you dont have as much control over the contents of the database tables themselves. A minimal configuration should look something like this:
Both the data files and the indexes should be striped over as many disk drives as necessary to achieve optimal I/O rates on those disks. From Chapter 14, Advanced Disk I/O Concepts, remember that you can only push a disk drive to a maximum random I/O rate.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |